﻿CREATE PROCEDURE [dbo].[sp_public_getCharacters]
	@Member_Id int
AS
SELECT Game_Name, Game_Id FROM Games WHERE EXISTS (SELECT Character_Game FROM Characters WHERE Games.Game_Id = Character_Game AND Character_MemberId = @Member_Id);
SELECT Realm_Id, Realm_Name, Realm_Game FROM Realms WHERE EXISTS (SELECT Character_Realm FROM Characters WHERE Realms.Realm_Id = Character_Realm AND Character_MemberId = @Member_Id);
SELECT Character_Id, Character_Name, Character_Realm FROM Characters WHERE Character_MemberId = @Member_Id;
RETURN 0